## # A tibble: 2 x 4
## # Groups: dayofweek [1]
## dayofweek IS_MEMBER AVG_COUNT AVG_DURATION
## <int> <chr> <dbl> <dbl>
## 1 1 false 5047. 26.0
## 2 1 true 7107. 13.4
Full year, weekly.
## day IS_MEMBER COUNT AVG_DURATION MIN_DURATION MAX_DURATION
## 1 2020-10-01 false 3247 20.54543 1 1255
## 2 2020-10-01 true 7730 12.22160 1 827
## STDDEV_DURATION year_month dayofweek weeknum
## 1 43.54311 2020-10 4 40
## 2 16.51734 2020-10 4 40
Note: not weighted average for the graph above.
## total_count monthly_avg_duration year_month type is_member
## 1 78447 29.93437 2020-10 docked_bike false
## 2 152515 13.96272 2020-10 docked_bike true
TODO — either use a weather-only dataset or show trips alongside weather.
## year_week is_member weekly_count weekly_avg_duration weekly_temp_min
## 1 2020-40 false 21188 25.62 6.53
## 2 2020-40 true 31032 13.62 6.53
## 3 2020-41 false 54067 28.55 10.63
## weekly_temp_avg weekly_temp_max weekly_wind_avg weekly_rain_total
## 1 10.13 13.75 3.23 8.1
## 2 10.13 13.75 3.23 8.1
## 3 16.29 22.86 4.50 0.0
## weekly_snow_total
## 1 0
## 2 0
## 3 0
TODO: Recompute on new daily aggregates.
## IS_MEMBER AVG_DURATION COUNT date temp_avg rain snow wind_avg
## 1 false 21.91015 3250 2020-10-01 11.6 5.3 0 3.8
## 2 false 34.67921 5287 2020-10-02 9.4 0.0 0 3.1
In degrees C.
Rain (mm) vs ride count
Wind (m/s) vs ride count.
Second graph is scaled to 100% to show member vs casual share.
1288 stations. Following: non-members vs members, 8am vs 4pm, Monday-Friday.
Each dot is a bike docking station. Stations highlighed yellow-red have more arrivals than departures for the given hour, suggesting an influx of bike traffic at that location.